Please note: this is a half-year full-time posting.

Supporting the modernization of the Social Assistance reporting platform (Legacy Cognos system), the Senior Business Analyst will work alongside the agile product team to review existing data model and redesign to be scalable and flexible to meet current program and Ministry needs for analytical and operational reporting.

1. Backlog Management: Collaborating with the Product Owner to prioritize and refine the product backlog, ensuring that user stories are well-defined and ready for development.
2. Sprint Planning: Participating in sprint planning meetings to help define the scope and objectives of each sprint, ensuring alignment with business goals.
3. Requirement Elicitation: Working closely with stakeholders and the development team to gather and clarify requirements, often through user stories and acceptance criteria.
4. Continuous Improvement: Engaging in sprint retrospectives to identify areas for improvement and implement changes to enhance team performance and product quality.
5. User Story Development: Writing and refining user stories, ensuring they are clear, concise, and actionable for the development team.
6. Stakeholder Collaboration: Facilitating communication between stakeholders and the development team to ensure that the delivered solutions meet business needs.
7. Documentation and Reporting: Maintaining up-to-date documentation and providing regular reports on project progress and performance metrics.

Hybrid Assignment: The consultant needs to work at the office (315 Front Street West, 3rd Floor) 3 days per week.

Business Analysis and Problem-Solving Skills - 35%

• Experienced in requirement elicitation, documentation, gap analysis, evaluation of alternative solutions, user interation/experience design (UI/UX) and making recommendations. (MUST HAVE)
• Experience facilitating sessions with a diverse audience for requirements discovery and analysis using a variety of methodologies (e.g. Agile/Waterfall/Hybrid). (MUST HAVE)
• Work with stakeholders (internal and external) across the program to develop clearly defined epics and user stories.
• Experience in writing user stories in Azure DevOps. (MUST HAVE)
• Gather information on client problems, services and business goals/objectives
• Help program understand their needs and translate to design models and concepts
• Evaluate requirements and review options for solution, assess cost/benefit of options, evaluate alternative conceptual systems designs and potential impact of proposed system changes on existing service delivery
• Recommend approaches and discuss with team and stakeholders
• Translate from technical terminology to business terms

Technical Knowledge and Expertise - 25%

• Led/managed business transformation/solution design initiatives, with a focus on business architecture and user interation/experience design (UI/UX). (MUST HAVE)
• Experience in conceptual design of enterprise data warehouses and extensive experience in data management supporting development teams - working on requirements gathering and design documentation
• Understand data warehouse modeling concepts and design principles (Kimball and Inmon)
• Advanced technical knowledge of large hardware and software operations and utilities, productivity tools, online processing systems, web-based technologies and database management systems
• Knowledge of enterprise architectural concepts and processes, specifically in the area of business architecture for data warehouses, marts, lakes (in Azure platform). (MUST HAVE)
• Knowledge of front end, web-based technologies and data-mining/reporting-based COTS tools (e.g., IBM CURAM) encompassing feasibility studies, requirements definition, analysis, prototyping, system design, implementation, testing and maintenance (Nice to have)
• Provide consultation on source to target mapping to ensure business and technical alignment
• Knowledge of Systems Development Life Cycle Methodologies, familiarity with ITIL Processes for Change/Release Management, relational data base technologies, use of information retrieval packages using SQL and other query languages.
• Knowledge of emerging IT trends and technologies - cloud computing, enterprise data warehousing, etc.
• Knowledge of accessibility compliance requirements e.g AODA, WCAG 2.1 Level A and AA or the most recent WCAG requirements

Organizational and Project Management Skills - 20%

• Plan, develop, manage, control projects and resolve complex technical design problems
• Knowledge of project management and in-depth knowledge of task estimation, scheduling and control
• Development of documentation and materials as part of a review and knowledge transfer to other members
• Development of specific activities as part of a review (hand over to ministry staff)and building block approach which, build on knowledge transfer and skills development from the previous stage to the next

Communication and Interpersonal Skills - 20%

• Gather information, clarify needs and desired system changes, explain system development recommendations, explain and provide instruction on new/modified systems and technology
• Prepare business cases, systems documentation, user manuals and guidelines
• Clarify and discuss systems development options with clients

No of maximum submissions :1 (one)

The consultant needs to come 3 days in the office per week. 

Must haves:

Please see highlighted in evaluation criteria